package com.education.project.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import com.education.project.model.LoginUserType;

public interface LoginUserTypeMapper {
	@Select("select id,typename from login_user_type where id=#{value}")
	public LoginUserType get(Integer id);
	
	@Select("select id,typename from login_user_type order by id")
	public List<LoginUserType> getall();
	
	@Insert("insert into login_user_type (id,typename) values (#{id},#{typename})")
	public void save(LoginUserType loginUserType);
	
	@Update("update login_user_type set typename=#{typename} where id=#{id}")
	public void update(LoginUserType loginUserType);
	
	@Delete("delete from login_user_type where id=#{value}")
	public void remove(Integer id);
}
